-- 智兔app-客户流失
CREATE external TABLE jms_dm.dm_network_customer_loss_statistics_dt(
  `input_date` date COMMENT '统计时间-运单录入时间',
  `network_code` string COMMENT '网点编码(寄件网点)',
  `network_name` string COMMENT '网点名称',
  `customer_moment` int COMMENT '当日客户量',
  `customer_moment_up` int COMMENT '上一日客户量',
  `customer_loss` int COMMENT '流失客户量',
  `customer_loss_up` int COMMENT '上一日流失客户量',
  `customer_active` int COMMENT '活跃客户量',
  `customer_active_up` int COMMENT '上一日活跃客户量',
  `customer_silent` int COMMENT '沉默客户量',
  `customer_silent_up` int COMMENT '上一日沉默客户量',
  `customer_incr` int COMMENT '当日新增客户量',
  `customer_incr_up` int COMMENT '上一日新增客户量')
COMMENT '智兔APP客户看板-客户流失'
PARTITIONED BY (
  `dt` string COMMENT '日时间分区-运单录入时间')
   STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_network_customer_loss_statistics_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );